UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sOoa37RYkbHRNABaeXevW+3hTc+4RIkqZDJETRvLOz8='
WHERE
key_id = 'b642c6dbdaa00328442a95e2dcf0f0c4ac8089eb2d9599bcd7741f24d26ce0c4'
AND (
token = 'sOoa37RYkbHRNABaeXevW+3hTc+4RIkqZDJETRvLOz8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)