UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K0QUKFP6yG89hA8gnilopWnXKapkTTQbgwifvKW1hG0='
WHERE
key_id = '2898079745ff7075929b9e40ed25dddebec7114c0263b830a8b9a4b0a2d58474'
AND (
token = 'K0QUKFP6yG89hA8gnilopWnXKapkTTQbgwifvKW1hG0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)