UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3OF0hCkODZ0EztwAIDd17a8by10WFk45B2q9H9ITcEs='
WHERE
key_id = '1b53edee4ad2633fe571b182445ca4056638df636c70dd1b0fa08fa75f5b8db8'
AND (
token = '3OF0hCkODZ0EztwAIDd17a8by10WFk45B2q9H9ITcEs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)