UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dfq/JS5CQyByepeKQvFtMERMgX7G3SMfn22zKU1BCP0='
WHERE
key_id = 'de31b53cad37c786b5028b09d5cb348d5ff689f88ab09de1d4de737692ee58ad'
AND (
token = 'dfq/JS5CQyByepeKQvFtMERMgX7G3SMfn22zKU1BCP0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)