UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'in0jGXMQN7DPBgjzxfgwxwDGoJbKHdpfJxVvvb3wTGU='
WHERE
key_id = '8d07f8a76dd14c34744c2df0aa8852fa62227e7b2266b9d65fc7ffda57447c47'
AND (
token = 'in0jGXMQN7DPBgjzxfgwxwDGoJbKHdpfJxVvvb3wTGU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)