UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z5Iz7yIAs+py/HivHiHR3Zz/AoDO0LgnMCftXx3LVr4='
WHERE
key_id = 'de13d8ff417f299c313c7a65e936450a75916857da3cc0e30ea4b149baf85085'
AND (
token = 'Z5Iz7yIAs+py/HivHiHR3Zz/AoDO0LgnMCftXx3LVr4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)