UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vMxQC9HpDnNZCMaWxIvwcmKSGCCP6cIc2bUS4HfM1Yo='
WHERE
key_id = '6a67a159397b85949c271229dab015cb289173ad55b82a9a3f19526d9e788dbf'
AND (
token = 'vMxQC9HpDnNZCMaWxIvwcmKSGCCP6cIc2bUS4HfM1Yo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)