UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uaBnDhw1N3kghJ2JHOMgm3rnozspYu8JApANCmM7SNo='
WHERE
key_id = 'aff554880b523a06d7f9c206c54d011644f145e00a7e2a4c5c386d35f8f2a726'
AND (
token = 'uaBnDhw1N3kghJ2JHOMgm3rnozspYu8JApANCmM7SNo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)