UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HCwb6vx/xQH+iiosMp+EIj97n+Gf9y91qMCX1c+F2iM='
WHERE
key_id = 'aefbbc58c286d44ba66a88d6b36443b576da696e85b8f214f7286a7461ceb72b'
AND (
token = 'HCwb6vx/xQH+iiosMp+EIj97n+Gf9y91qMCX1c+F2iM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)