UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QcDOgkq4ly9NqpVrEeX5S8yvXT7zMRZ+Vhtn+DdTxVk='
WHERE
key_id = 'ac31e9d5065049db35d0695604e74a0c9fb405d80d22a1042b3c41964d44b556'
AND (
token = 'QcDOgkq4ly9NqpVrEeX5S8yvXT7zMRZ+Vhtn+DdTxVk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)