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