UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xlI7pOIc72+KEgIa7llid0Z7ZDI6ZecyAlyIcO7uVyc='
WHERE
key_id = '00cb64e9e2368e10e5ea4c85dcb24b0ab694991c9091083be50f1bf4a6069c18'
AND (
token = 'xlI7pOIc72+KEgIa7llid0Z7ZDI6ZecyAlyIcO7uVyc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)