UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sG1itvxHg3WiUp3O9+5C+9cbMCMFjbxY8JlPAgR2X/E='
WHERE
key_id = '6745cc0b7dd4544dd7f085b1e9ac75c0a66745cf6237a6b9c975ceb8c90ce541'
AND (
token = 'sG1itvxHg3WiUp3O9+5C+9cbMCMFjbxY8JlPAgR2X/E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)