UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9nGBzkK31/b6S20EYazrfAZpiUZ1dSo/7QYt9uLf9sU='
WHERE
key_id = '6663b64a918308b6703c4397c9f9c206037f04c492e1b78e431dabf055188a14'
AND (
token = '9nGBzkK31/b6S20EYazrfAZpiUZ1dSo/7QYt9uLf9sU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)