UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GiXITT6epEGlE5A1tqC7kTue86ggLhaXAI2e9/OjX2k='
WHERE
key_id = 'f7c44fbe37f3418e3157b7fa8620bf4d867b8c0b636cd90e6bf2b5972680f147'
AND (
token = 'GiXITT6epEGlE5A1tqC7kTue86ggLhaXAI2e9/OjX2k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)