UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qtgA36LVXw852AkH2tznBImwUPEvUH3hbh3CLiwIejU='
WHERE
key_id = 'a6cea69cb553f030bc3c2f7f226e5bc556ab95b8c64af31d3903c4379f88327d'
AND (
token = 'qtgA36LVXw852AkH2tznBImwUPEvUH3hbh3CLiwIejU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)