UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k0nQCkhcJgyGNPSogna6FJa5udgf6+7zXX9Ac7kw/Nc='
WHERE
key_id = 'c6053085f8bf143369e65b5c247868054652b0c259eafe989be0d51ad6ef5a1a'
AND (
token = 'k0nQCkhcJgyGNPSogna6FJa5udgf6+7zXX9Ac7kw/Nc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)