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