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