UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hFclaPiDmg/cFxs22XUrxkfvywYO5fDSk63jsMksR/w='
WHERE
key_id = '29d2fbb5b6b9200b262e4f7b5e4eefde85c5f7faeb6e81e20c705bb871f7c461'
AND (
token = 'hFclaPiDmg/cFxs22XUrxkfvywYO5fDSk63jsMksR/w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)