UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5ZL/7oLOkqb6Iua3SrnSLo2K2IqgQ4CErw8KCb5dID0='
WHERE
key_id = 'bc96d9d7278e82ebbad3ef48b4f7e36a0d1bad28d0a4e19067626e3cb7e7e48a'
AND (
token = '5ZL/7oLOkqb6Iua3SrnSLo2K2IqgQ4CErw8KCb5dID0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)