UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '76f7abbtI9RGBLtXx+vw45JPzb/oyZTTiez92qErj+Q='
WHERE
key_id = '28b8a007e9109ce50c9596071478811cbe276c2f55630b00fdcb081d4a963caa'
AND (
token = '76f7abbtI9RGBLtXx+vw45JPzb/oyZTTiez92qErj+Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)