UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cg5dNXl1bSESLcTcoIqKPk+WHi9j8tmjBcV96IUVLBY='
WHERE
key_id = 'f458dc69140cb9730140a970cd6f1ad9bb39ec2f10f76d5b0aba5088d3a1f2e9'
AND (
token = 'cg5dNXl1bSESLcTcoIqKPk+WHi9j8tmjBcV96IUVLBY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)