UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ksAhiy6ea9pJ4Oc7+ehZBAz1vVXne8oSSOt9V7NMWuE='
WHERE
key_id = '27bc68065fb9601bf1d76f2e7176455ccdce263dbecf9d0417eb03ed8d06b16f'
AND (
token = 'ksAhiy6ea9pJ4Oc7+ehZBAz1vVXne8oSSOt9V7NMWuE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)