UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '4p92GTWcWoRqI2EQAzUyb5JkjV8skEmjz524S/VP9Lc=' 
WHERE 
  key_id = '58e87a6b97d2519ab9f21e8ff54b60512bdff4f48b83a0c8bd65b301dcf28128' 
  AND (
    token = '4p92GTWcWoRqI2EQAzUyb5JkjV8skEmjz524S/VP9Lc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035