UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bGsRoew71alazrpUxc97z5Kd5bOsTKQegbrnNfz6sgE='
WHERE
key_id = '305a92ad43167fc0af2561bb03237e6667b36ec78de01de7ebbbbbafe068ac2e'
AND (
token = 'bGsRoew71alazrpUxc97z5Kd5bOsTKQegbrnNfz6sgE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)