UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CGxQKoKQrhsddqMrTza3ghDf0eWkq1FevV6f2v+cuys='
WHERE
key_id = 'e7af927100c11a12e201bd9b85e364badc127c7df72914c015ab6339e13f400e'
AND (
token = 'CGxQKoKQrhsddqMrTza3ghDf0eWkq1FevV6f2v+cuys='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)