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