UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lX9TNmkbYQkRFgbAKlPE2pvq0xdy4vpyAVaFxXqYFDE='
WHERE
key_id = '2defddd4d9530b51129b82c8b349f4a424b98a537f16b50bdf0b93892963d3a1'
AND (
token = 'lX9TNmkbYQkRFgbAKlPE2pvq0xdy4vpyAVaFxXqYFDE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)