UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QgQNs6srUH1lHyaXWBAJkMCfIA7qFIKjKJj9UI2mvaM='
WHERE
key_id = '7ca33f238914cd28b837e11cd4475b4c83aa1fb611b44a7c2a7c3fe8980e1b5f'
AND (
token = 'QgQNs6srUH1lHyaXWBAJkMCfIA7qFIKjKJj9UI2mvaM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)