UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TDCsYOliw+hVOVyVsVhWmgH65PD9bZLf/iUNs2YoZZc='
WHERE
key_id = 'af12b39c711e70ebc1c50032e7f44ad066c05be31bbb7ce234edca761e48816a'
AND (
token = 'TDCsYOliw+hVOVyVsVhWmgH65PD9bZLf/iUNs2YoZZc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)