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