UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4LaV39SfPW6S02r8ABPbjEQBPrZrPdF7T48WF5AJfZg='
WHERE
key_id = '59b465db05d306e0ccd8050cc63a72950ff75e66e6f0641c030fa46dd881c251'
AND (
token = '4LaV39SfPW6S02r8ABPbjEQBPrZrPdF7T48WF5AJfZg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)