UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fIclhMoQwA7GQI3/CYjzO3bSlKGqpa/xdFb96veNsaY='
WHERE
key_id = '431d14244748ae424c2195e86236f291f84c7493a963a75d7b5d4ac9944ed789'
AND (
token = 'fIclhMoQwA7GQI3/CYjzO3bSlKGqpa/xdFb96veNsaY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)